Average (fld), Average (fld, condFld), Average (fld, condFld, cond), Average (x)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Enables you to average the values that appear in your report. For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

Average({orders.ORDER AMOUNT})

Calculates the average of all values in the Amount field.

Average ({orders.ORDER AMOUNT}, {customer.CUSTOMER ID})

Finds the average amount of a sale made to each customer.

The following example is applicable to Crystal syntax:

Average ([10,12,32,48])

Calculates the average of the values in an array of constants.

Note:    Using this function in a formula forces the formula to be evaluated at print time. For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com